CREATE TABLE [lgw].[Customers]
(
[CustomerId] [bigint] NOT NULL IDENTITY(1000000, 1),
[UserTypeId] [bigint] NOT NULL,
[UserName] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Password] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerStatusId] [bigint] NOT NULL,
[UpdatedAccountStatusDate] [datetime] NOT NULL,
[CreatedUser] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF__Customers__Creat__79FD19BE] DEFAULT (getdate()),
[UpdatedUser] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF__Customers__Updat__7AF13DF7] DEFAULT (getdate()),
[ReferenceBy] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReferenceCustomerId] [bigint] NULL
) ON [PRIMARY]
GO
